Table: Optional Fields Detail

Table: PMOFD
View: PM0500
Record length: 142
Flags: A R 

Keys: 1

Title  Flags  Fields
Optional Field Value   LOCATION, OPTFIELD

Fields: 29

Field  Type  Title  Presentation 
LOCATION  Integer  Location  List: 28 entries
1=Contracts
2=Projects
3=Categories
4=Employees
5=Equipment
6=Miscellaneous Expenses
7=Overhead Expenses
8=Subcontractors
10=Charge Codes
9=Material
100=Material Usage
101=Material Usage Details
110=Material Return
111=Material Return Details
120=Timecards
121=Timecards Details
122=Timecards Expenses
130=Equipment Usage
131=Equipment Usage Details
140=Charges
141=Charges Details
150=Adjustment
151=Adjustment Details
160=Revenue Recognition
170=Billing
171=Billing Detail
181=External Cost Transactions
190=Reopening Projects
OPTFIELD  String*12  Optional Field  Mask: %-12N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DEFVAL  String*60  Default Value  Mask: %-60c
TYPE  Integer  Data Type  List: 7 entries
1=Text
100=Amount
6=Number
8=Integer
9=Yes/No
3=Date
4=Time
LENGTH  Integer  Length   
DECIMALS  Integer  Decimals   
ALLOWNULL  Boolean  Allow Blank  List: 2 entries
0=No
1=Yes
VALIDATE  Boolean  Validate Optional Field  List: 2 entries
0=No
1=Yes
INITFLAG  Integer  Init Flag  List: 2 entries
0=No
1=Yes
SWICSHP  Integer  Inventory Control Shipments   
SWICSHPD  Integer  Inventory Control Shipments Deta   
SWICADJ  Integer  Inventory Control Adjustments   
SWICADJD  Integer  Inventory Control Adjustments De   
SWPAYTC  Integer  Payroll Timecards   
SWPAYTCD  Integer  Payroll Timecard Details   
SWWIP  Integer  Work In Progress   
SWCOS  Integer  Cost of Sales   
SWPAYEXP  Integer  Payroll Expense   
SWLABOR  Integer  Labor   
SWOHEAD  Integer  Overhead   
SWEQUIP  Integer  Equipment   
SWEMPEXP  Integer  Employee Expense   
SWARINV  Integer  Accounts Receivable Invoices   
SWREV  Integer  Revenue   
SWBILL  Integer  Billings   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.